Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	708
Missing cells	4556
Missing cells (%)	26.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 MiB
Average record size in memory	1.5 KiB

Variable types

Numeric	8
URL	3
Text	4
Categorical	4
Unsupported	3
DateTime	2

Alerts

`averageRuntime` is highly overall correlated with `runtime`	High correlation
`externals_thetvdb` is highly overall correlated with `externals_tvrage` and 1 other fields	High correlation
`externals_tvrage` is highly overall correlated with `externals_thetvdb`	High correlation
`id` is highly overall correlated with `externals_thetvdb` and 1 other fields	High correlation
`runtime` is highly overall correlated with `averageRuntime`	High correlation
`weight` is highly overall correlated with `id`	High correlation
`schedule_time` is highly imbalanced (58.2%)	Imbalance
`language` has 45 (6.4%) missing values	Missing
`genres` has 253 (35.7%) missing values	Missing
`runtime` has 555 (78.4%) missing values	Missing
`averageRuntime` has 57 (8.1%) missing values	Missing
`ended` has 531 (75.0%) missing values	Missing
`officialSite` has 80 (11.3%) missing values	Missing
`schedule_days` has 217 (30.6%) missing values	Missing
`rating` has 582 (82.2%) missing values	Missing
`summary` has 96 (13.6%) missing values	Missing
`webChannel_name` has 20 (2.8%) missing values	Missing
`webChannel_site` has 188 (26.6%) missing values	Missing
`dvd_country` has 705 (99.6%) missing values	Missing
`externals_tvrage` has 685 (96.8%) missing values	Missing
`externals_thetvdb` has 198 (28.0%) missing values	Missing
`externals_imdb` has 344 (48.6%) missing values	Missing
`id` has unique values	Unique
`url` has unique values	Unique
`updated` has unique values	Unique
`genres` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`schedule_days` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`dvd_country` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`weight` has 12 (1.7%) zeros	Zeros

Reproduction

Analysis started	2025-02-10 19:27:29.353649
Analysis finished	2025-02-10 19:27:42.781568
Duration	13.43 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

id
Real number (ℝ)

High correlation Unique

Distinct	708
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61329.328

Minimum	274
Maximum	82453
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	274
5-th percentile	11697.3
Q1	54985.5
median	69427.5
Q3	73898.5
95-th percentile	78146.3
Maximum	82453
Range	82179
Interquartile range (IQR)	18913

Descriptive statistics

Standard deviation	19377.282
Coefficient of variation (CV)	0.31595457
Kurtosis	2.0106714
Mean	61329.328
Median Absolute Deviation (MAD)	5995.5
Skewness	-1.6536618
Sum	43421164
Variance	3.7547904 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51908	1	0.1%
74082	1	0.1%
66342	1	0.1%
26350	1	0.1%
76058	1	0.1%
58177	1	0.1%
74141	1	0.1%
6141	1	0.1%
55986	1	0.1%
57945	1	0.1%
Other values (698)	698	98.6%

Value	Count	Frequency (%)
274	1	0.1%
703	1	0.1%
718	1	0.1%
729	1	0.1%
793	1	0.1%
802	1	0.1%
812	1	0.1%
875	1	0.1%
920	1	0.1%
938	1	0.1%

Value	Count	Frequency (%)
82453	1	0.1%
82397	1	0.1%
82316	1	0.1%
82298	1	0.1%
81933	1	0.1%
81893	1	0.1%
81775	1	0.1%
81758	1	0.1%
81749	1	0.1%
81561	1	0.1%

url
URL

Unique

Distinct	708
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	75.5 KiB

https://www.tvmaze.com/shows/51908/neznost	1
https://www.tvmaze.com/shows/74082/girls-play	1
https://www.tvmaze.com/shows/66342/carina-bergfeldt	1
https://www.tvmaze.com/shows/26350/nytt-pa-nytt	1
https://www.tvmaze.com/shows/76058/the-uplift	1
Other values (703)	703

Value	Count	Frequency (%)
https://www.tvmaze.com/shows/51908/neznost	1	0.1%
https://www.tvmaze.com/shows/74082/girls-play	1	0.1%
https://www.tvmaze.com/shows/66342/carina-bergfeldt	1	0.1%
https://www.tvmaze.com/shows/26350/nytt-pa-nytt	1	0.1%
https://www.tvmaze.com/shows/76058/the-uplift	1	0.1%
https://www.tvmaze.com/shows/58177/the-traitors	1	0.1%
https://www.tvmaze.com/shows/74141/wang-zhe-rongyao	1	0.1%
https://www.tvmaze.com/shows/6141/simons-cat	1	0.1%
https://www.tvmaze.com/shows/55986/journey-across-japan	1	0.1%
https://www.tvmaze.com/shows/57945/i-like-to-watch	1	0.1%
Other values (698)	698	98.6%

Value	Count	Frequency (%)
https	708	100.0%

Value	Count	Frequency (%)
www.tvmaze.com	708	100.0%

Value	Count	Frequency (%)
/shows/51908/neznost	1	0.1%
/shows/74082/girls-play	1	0.1%
/shows/66342/carina-bergfeldt	1	0.1%
/shows/26350/nytt-pa-nytt	1	0.1%
/shows/76058/the-uplift	1	0.1%
/shows/58177/the-traitors	1	0.1%
/shows/74141/wang-zhe-rongyao	1	0.1%
/shows/6141/simons-cat	1	0.1%
/shows/55986/journey-across-japan	1	0.1%
/shows/57945/i-like-to-watch	1	0.1%
Other values (698)	698	98.6%

Value	Count	Frequency (%)
	708	100.0%

Value	Count	Frequency (%)
	708	100.0%

name
Text

Distinct	706
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Memory size	58.7 KiB

Length

Max length	63
Median length	40
Mean length	17.326271
Min length	2

Characters and Unicode

Total characters	12267
Distinct characters	167
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	704 ?
Unique (%)	99.4%

Sample

1st row	Нежность
2nd row	Предпоследняя инстанция
3rd row	Манюня
4th row	Недетское кино
5th row	Успешный

Value	Count	Frequency (%)
the	111	5.2%
of	39	1.8%
with	21	1.0%
a	20	0.9%
	18	0.8%
love	15	0.7%
and	15	0.7%
in	12	0.6%
you	12	0.6%
no	11	0.5%
Other values (1438)	1868	87.2%

Most occurring characters

Value	Count	Frequency (%)
	1434	11.7%
e	1066	8.7%
a	727	5.9%
n	634	5.2%
o	630	5.1%
i	612	5.0%
r	560	4.6%
t	505	4.1%
s	460	3.7%
h	352	2.9%
Other values (157)	5287	43.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12267	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1434	11.7%
e	1066	8.7%
a	727	5.9%
n	634	5.2%
o	630	5.1%
i	612	5.0%
r	560	4.6%
t	505	4.1%
s	460	3.7%
h	352	2.9%
Other values (157)	5287	43.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12267	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1434	11.7%
e	1066	8.7%
a	727	5.9%
n	634	5.2%
o	630	5.1%
i	612	5.0%
r	560	4.6%
t	505	4.1%
s	460	3.7%
h	352	2.9%
Other values (157)	5287	43.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12267	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1434	11.7%
e	1066	8.7%
a	727	5.9%
n	634	5.2%
o	630	5.1%
i	612	5.0%
r	560	4.6%
t	505	4.1%
s	460	3.7%
h	352	2.9%
Other values (157)	5287	43.1%

type
Categorical

Distinct	11
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	45.3 KiB

Scripted	229
Animation	117
Documentary	90
Reality	90
Talk Show	80
Other values (6)	102

Length

Max length	11
Median length	10
Mean length	8.3206215
Min length	4

Characters and Unicode

Total characters	5891
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Scripted
2nd row	Scripted
3rd row	Scripted
4th row	Scripted
5th row	Scripted

Common Values

Value	Count	Frequency (%)
Scripted	229	32.3%
Animation	117	16.5%
Documentary	90	12.7%
Reality	90	12.7%
Talk Show	80	11.3%
News	38	5.4%
Game Show	32	4.5%
Variety	14	2.0%
Sports	13	1.8%
Panel Show	4	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
scripted	229	27.8%
animation	117	14.2%
show	117	14.2%
documentary	90	10.9%
reality	90	10.9%
talk	80	9.7%
news	38	4.6%
game	32	3.9%
variety	14	1.7%
sports	13	1.6%
Other values (2)	5	0.6%

Most occurring characters

Value	Count	Frequency (%)
i	567	9.6%
t	553	9.4%
e	497	8.4%
a	428	7.3%
S	359	6.1%
r	347	5.9%
o	337	5.7%
n	328	5.6%
c	319	5.4%
p	242	4.1%
Other values (18)	1914	32.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5891	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	567	9.6%
t	553	9.4%
e	497	8.4%
a	428	7.3%
S	359	6.1%
r	347	5.9%
o	337	5.7%
n	328	5.6%
c	319	5.4%
p	242	4.1%
Other values (18)	1914	32.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5891	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	567	9.6%
t	553	9.4%
e	497	8.4%
a	428	7.3%
S	359	6.1%
r	347	5.9%
o	337	5.7%
n	328	5.6%
c	319	5.4%
p	242	4.1%
Other values (18)	1914	32.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5891	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	567	9.6%
t	553	9.4%
e	497	8.4%
a	428	7.3%
S	359	6.1%
r	347	5.9%
o	337	5.7%
n	328	5.6%
c	319	5.4%
p	242	4.1%
Other values (18)	1914	32.5%

language
Categorical

Missing

Distinct	33
Distinct (%)	5.0%
Missing	45
Missing (%)	6.4%
Memory size	44.0 KiB

English	274
Chinese	117
Russian	64
Norwegian	31
Swedish	23
Other values (28)	154

Length

Max length	10
Median length	7
Mean length	6.984917
Min length	4

Characters and Unicode

Total characters	4631
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	1.5%

Sample

1st row	Russian
2nd row	Russian
3rd row	Russian
4th row	Russian
5th row	English

Common Values

Value	Count	Frequency (%)
English	274	38.7%
Chinese	117	16.5%
Russian	64	9.0%
Norwegian	31	4.4%
Swedish	23	3.2%
Korean	22	3.1%
Japanese	15	2.1%
Spanish	12	1.7%
French	11	1.6%
Thai	10	1.4%
Other values (23)	84	11.9%
(Missing)	45	6.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
english	274	41.3%
chinese	117	17.6%
russian	64	9.7%
norwegian	31	4.7%
swedish	23	3.5%
korean	22	3.3%
japanese	15	2.3%
spanish	12	1.8%
french	11	1.7%
thai	10	1.5%
Other values (23)	84	12.7%

Most occurring characters

Value	Count	Frequency (%)
i	610	13.2%
n	609	13.2%
s	598	12.9%
h	480	10.4%
e	374	8.1%
g	311	6.7%
l	287	6.2%
E	274	5.9%
a	236	5.1%
C	119	2.6%
Other values (32)	733	15.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4631	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	610	13.2%
n	609	13.2%
s	598	12.9%
h	480	10.4%
e	374	8.1%
g	311	6.7%
l	287	6.2%
E	274	5.9%
a	236	5.1%
C	119	2.6%
Other values (32)	733	15.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4631	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	610	13.2%
n	609	13.2%
s	598	12.9%
h	480	10.4%
e	374	8.1%
g	311	6.7%
l	287	6.2%
E	274	5.9%
a	236	5.1%
C	119	2.6%
Other values (32)	733	15.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4631	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	610	13.2%
n	609	13.2%
s	598	12.9%
h	480	10.4%
e	374	8.1%
g	311	6.7%
l	287	6.2%
E	274	5.9%
a	236	5.1%
C	119	2.6%
Other values (32)	733	15.8%

genres
Unsupported

Missing Rejected Unsupported

Missing	253
Missing (%)	35.7%
Memory size	50.7 KiB

status
Categorical

Distinct	3
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	44.9 KiB

Running	436
Ended	177
To Be Determined	95

Length

Max length	16
Median length	7
Mean length	7.7076271
Min length	5

Characters and Unicode

Total characters	5457
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ended
2nd row	Ended
3rd row	Running
4th row	Running
5th row	Running

Common Values

Value	Count	Frequency (%)
Running	436	61.6%
Ended	177	25.0%
To Be Determined	95	13.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
running	436	48.6%
ended	177	19.7%
to	95	10.6%
be	95	10.6%
determined	95	10.6%

Most occurring characters

Value	Count	Frequency (%)
n	1580	29.0%
e	557	10.2%
i	531	9.7%
d	449	8.2%
R	436	8.0%
u	436	8.0%
g	436	8.0%
	190	3.5%
E	177	3.2%
T	95	1.7%
Other values (6)	570	10.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5457	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	1580	29.0%
e	557	10.2%
i	531	9.7%
d	449	8.2%
R	436	8.0%
u	436	8.0%
g	436	8.0%
	190	3.5%
E	177	3.2%
T	95	1.7%
Other values (6)	570	10.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5457	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	1580	29.0%
e	557	10.2%
i	531	9.7%
d	449	8.2%
R	436	8.0%
u	436	8.0%
g	436	8.0%
	190	3.5%
E	177	3.2%
T	95	1.7%
Other values (6)	570	10.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5457	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	1580	29.0%
e	557	10.2%
i	531	9.7%
d	449	8.2%
R	436	8.0%
u	436	8.0%
g	436	8.0%
	190	3.5%
E	177	3.2%
T	95	1.7%
Other values (6)	570	10.4%

runtime
Real number (ℝ)

High correlation Missing

Distinct	46
Distinct (%)	30.1%
Missing	555
Missing (%)	78.4%
Infinite	0
Infinite (%)	0.0%
Mean	46.398693

Minimum	1
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	19
median	30
Q3	60
95-th percentile	132
Maximum	300
Range	299
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	46.832054
Coefficient of variation (CV)	1.00934
Kurtosis	8.0695349
Mean	46.398693
Median Absolute Deviation (MAD)	19
Skewness	2.5142541
Sum	7099
Variance	2193.2413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
60	25	3.5%
30	20	2.8%
20	8	1.1%
120	8	1.1%
24	6	0.8%
10	6	0.8%
25	6	0.8%
5	6	0.8%
45	6	0.8%
12	5	0.7%
Other values (36)	57	8.1%
(Missing)	555	78.4%

Value	Count	Frequency (%)
1	1	0.1%
2	2	0.3%
3	1	0.1%
4	1	0.1%
5	6	0.8%
6	1	0.1%
7	1	0.1%
8	3	0.4%
10	6	0.8%
11	3	0.4%

Value	Count	Frequency (%)
300	1	0.1%
240	1	0.1%
210	1	0.1%
180	3	0.4%
159	1	0.1%
150	1	0.1%
120	8	1.1%
90	3	0.4%
70	1	0.1%
65	1	0.1%

averageRuntime
Real number (ℝ)

High correlation Missing

Distinct	101
Distinct (%)	15.5%
Missing	57
Missing (%)	8.1%
Infinite	0
Infinite (%)	0.0%
Mean	42.560676

Minimum	1
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	22
median	40
Q3	53.5
95-th percentile	102.5
Maximum	300
Range	299
Interquartile range (IQR)	31.5

Descriptive statistics

Standard deviation	35.269432
Coefficient of variation (CV)	0.82868591
Kurtosis	13.021811
Mean	42.560676
Median Absolute Deviation (MAD)	16
Skewness	2.9742766
Sum	27707
Variance	1243.9329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	40	5.6%
45	40	5.6%
60	39	5.5%
43	23	3.2%
25	23	3.2%
10	22	3.1%
15	21	3.0%
20	16	2.3%
12	14	2.0%
24	14	2.0%
Other values (91)	399	56.4%
(Missing)	57	8.1%

Value	Count	Frequency (%)
1	2	0.3%
2	6	0.8%
3	5	0.7%
4	3	0.4%
5	7	1.0%
6	6	0.8%
7	6	0.8%
8	6	0.8%
9	4	0.6%
10	22	3.1%

Value	Count	Frequency (%)
300	1	0.1%
242	1	0.1%
240	3	0.4%
219	1	0.1%
194	1	0.1%
184	1	0.1%
180	5	0.7%
177	1	0.1%
164	1	0.1%
163	1	0.1%

premiered
Date

Distinct	470
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Memory size	5.7 KiB

Minimum	1944-01-20 00:00:00
Maximum	2024-11-25 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ended
Date

Missing

Distinct	81
Distinct (%)	45.8%
Missing	531
Missing (%)	75.0%
Memory size	5.7 KiB

Minimum	2024-01-01 00:00:00
Maximum	2024-11-15 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

officialSite
URL

Missing

Distinct	625
Distinct (%)	99.5%
Missing	80
Missing (%)	11.3%
Memory size	70.1 KiB

https://abcnews.go.com/Live	4
https://www.ivi.ru/watch/nezhnost	1
https://www.youtube.com/playlist?list=PLs9aWCCF6Oy6CnOuLsq3GuDsb-9lZFrEf	1
https://www.svtplay.se/carina-bergfeldt	1
https://tv.nrk.no/serie/nytt-paa-nytt	1
Other values (620)	620
(Missing)	80

Value	Count	Frequency (%)
https://abcnews.go.com/Live	4	0.6%
https://www.ivi.ru/watch/nezhnost	1	0.1%
https://www.youtube.com/playlist?list=PLs9aWCCF6Oy6CnOuLsq3GuDsb-9lZFrEf	1	0.1%
https://www.svtplay.se/carina-bergfeldt	1	0.1%
https://tv.nrk.no/serie/nytt-paa-nytt	1	0.1%
https://www.cbsnews.com/uplift/	1	0.1%
https://www.peacocktv.com/stream-tv/the-traitors	1	0.1%
http://simonscat.com	1	0.1%
https://www.youtube.com/channel/UCHL9bfHTxCMi-7vfxQ-AYtg	1	0.1%
https://m.youtube.com/playlist?list=PL2Hx2rn1E3W5U-D0uLp8znb0RqKyXlC9L	1	0.1%
Other values (615)	615	86.9%
(Missing)	80	11.3%

Value	Count	Frequency (%)
https	590	83.3%
http	38	5.4%
(Missing)	80	11.3%

Value	Count	Frequency (%)
www.youtube.com	55	7.8%
v.qq.com	51	7.2%
www.bbc.co.uk	36	5.1%
www.netflix.com	33	4.7%
www.svtplay.se	17	2.4%
www.primevideo.com	17	2.4%
v.youku.com	15	2.1%
vk.com	15	2.1%
tv.nrk.no	13	1.8%
www.disneyplus.com	12	1.7%
Other values (199)	364	51.4%
(Missing)	80	11.3%

Value	Count	Frequency (%)
/playlist	25	3.5%
/	25	3.5%
	6	0.8%
/Live	4	0.6%
/watch	3	0.4%
/x/search/	3	0.4%
/serier/paradise-hotel	2	0.3%
/programmes/p01djw5m	1	0.1%
/show/revenge-our-dad-the-nazi-killer	1	0.1%
/show/muster-dogs	1	0.1%
Other values (557)	557	78.7%
(Missing)	80	11.3%

Value	Count	Frequency (%)
	556	78.5%
spm=a2h0c.8166622.PhoneSokuProgram_1.dtitle	7	1.0%
lang=en_us	7	1.0%
spm=a2hbt.13141534.left-title-content-wrap.5~A	2	0.3%
list=PLShD8ZZW7qjmr-4yP8PpmnMhIjYv163fB	1	0.1%
spm_id_from=333.337.0.0	1	0.1%
s=acbfc1fe6bf948f7a3f7	1	0.1%
v=KsjjpB-EKdE&list=PLV8Q_exbQpnah3PkCNG8ao4sbWxqFdjSY	1	0.1%
view=50&sort=dd&shelf_id=5	1	0.1%
list=PLGwZKkKxJCidbu9qsXqjbvuLrbaayULav&si=rvA0JETf56jbjA3p	1	0.1%
Other values (50)	50	7.1%
(Missing)	80	11.3%

Value	Count	Frequency (%)
	626	88.4%
!/	1	0.1%
detail	1	0.1%
(Missing)	80	11.3%

schedule_time
Categorical

Imbalance

Distinct	47
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Memory size	40.6 KiB

	480
10:00	35
12:00	32
20:00	20
00:00	15
Other values (42)	126

Length

Max length	5
Median length	0
Mean length	1.6101695
Min length	0

Characters and Unicode

Total characters	1140
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	3.8%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	480	67.8%
10:00	35	4.9%
12:00	32	4.5%
20:00	20	2.8%
00:00	15	2.1%
06:00	14	2.0%
18:00	14	2.0%
21:00	13	1.8%
02:00	11	1.6%
19:00	8	1.1%
Other values (37)	66	9.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
10:00	35	15.4%
12:00	32	14.0%
20:00	20	8.8%
00:00	15	6.6%
06:00	14	6.1%
18:00	14	6.1%
21:00	13	5.7%
02:00	11	4.8%
17:00	8	3.5%
19:00	8	3.5%
Other values (36)	58	25.4%

Most occurring characters

Value	Count	Frequency (%)
0	547	48.0%
:	228	20.0%
1	145	12.7%
2	103	9.0%
3	32	2.8%
9	19	1.7%
6	18	1.6%
8	17	1.5%
7	15	1.3%
5	11	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1140	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	547	48.0%
:	228	20.0%
1	145	12.7%
2	103	9.0%
3	32	2.8%
9	19	1.7%
6	18	1.6%
8	17	1.5%
7	15	1.3%
5	11	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1140	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	547	48.0%
:	228	20.0%
1	145	12.7%
2	103	9.0%
3	32	2.8%
9	19	1.7%
6	18	1.6%
8	17	1.5%
7	15	1.3%
5	11	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1140	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	547	48.0%
:	228	20.0%
1	145	12.7%
2	103	9.0%
3	32	2.8%
9	19	1.7%
6	18	1.6%
8	17	1.5%
7	15	1.3%
5	11	1.0%

schedule_days
Unsupported

Missing Rejected Unsupported

Missing	217
Missing (%)	30.6%
Memory size	55.6 KiB

rating
Real number (ℝ)

Missing

Distinct	43
Distinct (%)	34.1%
Missing	582
Missing (%)	82.2%
Infinite	0
Infinite (%)	0.0%
Mean	6.4888889

Minimum	1
Maximum	8.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1
5-th percentile	4.15
Q1	6
median	6.8
Q3	7.4
95-th percentile	8
Maximum	8.2
Range	7.2
Interquartile range (IQR)	1.4

Descriptive statistics

Standard deviation	1.3969809
Coefficient of variation (CV)	0.21528815
Kurtosis	4.6906975
Mean	6.4888889
Median Absolute Deviation (MAD)	0.65
Skewness	-1.9253958
Sum	817.6
Variance	1.9515556
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
7.2	8	1.1%
7.4	7	1.0%
7.3	6	0.8%
7	6	0.8%
6.6	6	0.8%
8	6	0.8%
6.8	6	0.8%
7.8	5	0.7%
7.1	5	0.7%
6.3	5	0.7%
Other values (33)	66	9.3%
(Missing)	582	82.2%

Value	Count	Frequency (%)
1	2	0.3%
1.3	1	0.1%
2.1	1	0.1%
2.2	1	0.1%
4.1	2	0.3%
4.3	1	0.1%
4.4	1	0.1%
4.6	1	0.1%
4.7	1	0.1%
4.8	1	0.1%

Value	Count	Frequency (%)
8.2	1	0.1%
8.1	1	0.1%
8	6	0.8%
7.9	3	0.4%
7.8	5	0.7%
7.7	4	0.6%
7.6	4	0.6%
7.5	3	0.4%
7.4	7	1.0%
7.3	6	0.8%

weight
Real number (ℝ)

High correlation Zeros

Distinct	99
Distinct (%)	14.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.526836

Minimum	0
Maximum	100
Zeros	12
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.35
Q1	8
median	32
Q3	61
95-th percentile	94
Maximum	100
Range	100
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	30.863538
Coefficient of variation (CV)	0.82243912
Kurtosis	-0.98514753
Mean	37.526836
Median Absolute Deviation (MAD)	24
Skewness	0.57198329
Sum	26569
Variance	952.55798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	38	5.4%
7	36	5.1%
6	27	3.8%
3	25	3.5%
4	23	3.2%
23	21	3.0%
13	19	2.7%
11	16	2.3%
18	14	2.0%
1	14	2.0%
Other values (89)	475	67.1%

Value	Count	Frequency (%)
0	12	1.7%
1	14	2.0%
2	10	1.4%
3	25	3.5%
4	23	3.2%
5	5	0.7%
6	27	3.8%
7	36	5.1%
8	38	5.4%
9	4	0.6%

Value	Count	Frequency (%)
100	1	0.1%
99	7	1.0%
98	8	1.1%
97	5	0.7%
96	7	1.0%
95	7	1.0%
94	6	0.8%
93	6	0.8%
92	6	0.8%
91	2	0.3%

summary
Text

Missing

Distinct	612
Distinct (%)	100.0%
Missing	96
Missing (%)	13.6%
Memory size	327.3 KiB

Length

Max length	1931
Median length	515
Mean length	351.35621
Min length	39

Characters and Unicode

Total characters	215030
Distinct characters	301
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	612 ?
Unique (%)	100.0%

Sample

1st row	<p>30-year-old Sasha is a serial loser trying with all his might to become a successful business coach. Fate leads him to billionaire Oleg Kalugin, who decides to hire the resilient dreamer as a coach. However, Kalugin does not need advice on business, which the guy knows nothing about, but the secret of his ability to sincerely enjoy life despite poverty and other problems. From this moment, drastic changes begin in Sasha's life, which show the real price of success. Step by step, he moves further and further away from happiness, plunging into the world of deception, betrayal, hatred and really big, but dirty money.</p>
2nd row	<p>Lulin wasn't expecting to develop alien powers, or intergalactic invaders to crash her school science comp, but hey, Year 6 is full of surprises!</p>
3rd row	<p>Ten thousand years ago, Muyun's fairy King was secretly accounted for by holding a Zhuxian figure, and after a long sleep, he awakened in the famous "Muyun waste" of the southern Yun Empire in the Land of Heaven. When Muyun first woke up, he was deliberately bothered by the student Miaoxianyu. Muyun easily completed the Miaoxianyu trap, and he gave more and more alchemy skills by analogy, so the Alchemy masters outside the door could not ask for appreciation. Endless back home, Mu Yun learns that he is about to marry Nona Qin Qin Mengyao. Qin Mengyao was cold and toxic, but could not live until he was 20 years old. The marriage was only for the sake of pastoralists and family of Qin. However, under Mu Linchen's enticement, Mu Yun approves the family's issue on the condition of alchemy.</p><p><br /> </p>
4th row	<p>The former mighty Gods of the heavens, after ten thousand lifetimes of reincarnation tragically destroyed! The cruel curse, the hatred of ten thousand lives, Tan Yun determined, no longer sink! The most important thing is that you have to be able to get to the top of the world, step by step, stepping on the corpses of your enemies! To kill against the sky, across all the worlds, only I am the supreme!</p>
5th row	<p>Of all the races in the world only 3 stand at the top. Each race possesses a master of the martial arts, a Golden Martial God. The balance of power appears to be shifting after Wang Fan's brother is killed triggering a chain of events that will begin to turn the world upside down. Disguising himself as the Silver Tiger King, Wang Fan becomes a symbol of power and the hope of the human race.<br />Some days Wang Fan is a boy genius that tries to blend in as a smart but helpless student. Other days he becomes a powerful tiger. Every race has their eyes on the Silver Tiger King as he continues to surpass every precedent and excel far beyond his peers all while under the guise of an unassuming student.</p>

Value	Count	Frequency (%)
the	2180	6.2%
and	1266	3.6%
of	1053	3.0%
a	958	2.7%
to	896	2.5%
in	671	1.9%
is	416	1.2%
with	334	0.9%
on	274	0.8%
his	274	0.8%
Other values (8401)	26839	76.3%

Most occurring characters

Value	Count	Frequency (%)
	34501	16.0%
e	20605	9.6%
t	13782	6.4%
a	13154	6.1%
i	12370	5.8%
n	12171	5.7%
o	12067	5.6%
s	11213	5.2%
r	10384	4.8%
h	8707	4.0%
Other values (291)	66076	30.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	215030	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	34501	16.0%
e	20605	9.6%
t	13782	6.4%
a	13154	6.1%
i	12370	5.8%
n	12171	5.7%
o	12067	5.6%
s	11213	5.2%
r	10384	4.8%
h	8707	4.0%
Other values (291)	66076	30.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	215030	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	34501	16.0%
e	20605	9.6%
t	13782	6.4%
a	13154	6.1%
i	12370	5.8%
n	12171	5.7%
o	12067	5.6%
s	11213	5.2%
r	10384	4.8%
h	8707	4.0%
Other values (291)	66076	30.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	215030	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	34501	16.0%
e	20605	9.6%
t	13782	6.4%
a	13154	6.1%
i	12370	5.8%
n	12171	5.7%
o	12067	5.6%
s	11213	5.2%
r	10384	4.8%
h	8707	4.0%
Other values (291)	66076	30.7%

webChannel_name
Text

Missing

Distinct	147
Distinct (%)	21.4%
Missing	20
Missing (%)	2.8%
Memory size	46.0 KiB

Length

Max length	24
Median length	22
Mean length	8.1584302
Min length	3

Characters and Unicode

Total characters	5613
Distinct characters	83
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	10.2%

Sample

1st row	Иви
2nd row	Okko
3rd row	Okko
4th row	Wink
5th row	KION

Value	Count	Frequency (%)
youtube	101	10.0%
qq	55	5.4%
tencent	55	5.4%
tv	44	4.3%
netflix	35	3.5%
bbc	35	3.5%
iplayer	35	3.5%
play	35	3.5%
youku	28	2.8%
video	25	2.5%
Other values (179)	565	55.8%

Most occurring characters

Value	Count	Frequency (%)
e	511	9.1%
i	329	5.9%
	325	5.8%
u	314	5.6%
o	293	5.2%
T	272	4.8%
n	238	4.2%
a	237	4.2%
l	202	3.6%
t	196	3.5%
Other values (73)	2696	48.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	511	9.1%
i	329	5.9%
	325	5.8%
u	314	5.6%
o	293	5.2%
T	272	4.8%
n	238	4.2%
a	237	4.2%
l	202	3.6%
t	196	3.5%
Other values (73)	2696	48.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	511	9.1%
i	329	5.9%
	325	5.8%
u	314	5.6%
o	293	5.2%
T	272	4.8%
n	238	4.2%
a	237	4.2%
l	202	3.6%
t	196	3.5%
Other values (73)	2696	48.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	511	9.1%
i	329	5.9%
	325	5.8%
u	314	5.6%
o	293	5.2%
T	272	4.8%
n	238	4.2%
a	237	4.2%
l	202	3.6%
t	196	3.5%
Other values (73)	2696	48.0%

webChannel_site
URL

Missing

Distinct	90
Distinct (%)	17.3%
Missing	188
Missing (%)	26.6%
Memory size	47.2 KiB

https://www.youtube.com	101
https://v.qq.com/	55
https://www.netflix.com/	35
https://www.bbc.co.uk/iplayer	35
https://www.primevideo.com	24
Other values (85)	270
(Missing)	188

Value	Count	Frequency (%)
https://www.youtube.com	101	14.3%
https://v.qq.com/	55	7.8%
https://www.netflix.com/	35	4.9%
https://www.bbc.co.uk/iplayer	35	4.9%
https://www.primevideo.com	24	3.4%
https://www.iq.com/	23	3.2%
https://www.svtplay.se/	18	2.5%
https://www.peacocktv.com/	14	2.0%
https://tv.nrk.no	13	1.8%
https://www.disneyplus.com/	12	1.7%
Other values (80)	190	26.8%
(Missing)	188	26.6%

Value	Count	Frequency (%)
https	514	72.6%
http	6	0.8%
(Missing)	188	26.6%

Value	Count	Frequency (%)
www.youtube.com	101	14.3%
v.qq.com	55	7.8%
www.netflix.com	35	4.9%
www.bbc.co.uk	35	4.9%
www.primevideo.com	24	3.4%
www.iq.com	23	3.2%
www.svtplay.se	18	2.5%
www.peacocktv.com	14	2.0%
tv.nrk.no	13	1.8%
www.disneyplus.com	12	1.7%
Other values (80)	190	26.8%
(Missing)	188	26.6%

Value	Count	Frequency (%)
/	290	41.0%
	153	21.6%
/iplayer	35	4.9%
/video/@vkvideo	7	1.0%
/en	5	0.7%
/Live	4	0.6%
/onboarding	4	0.6%
/adlp/freevee-about	3	0.4%
/network/	2	0.3%
/home	2	0.3%
Other values (13)	15	2.1%
(Missing)	188	26.6%

Value	Count	Frequency (%)
	512	72.3%
hpt=header_edition-picker	6	0.8%
utm_source=google&utm_campaign=gads_search_brand&utm_medium=cpc&utm_term=pure%20flix&hsa_ver=3&hsa_grp=68693273966&hsa_acc=9355037628&hsa_ad=676826129706&hsa_src=g&hsa_tgt=kwd-325450860434&hsa_kw=pure%20f	1	0.1%
ref=d6k_applink_bb_dls&dplnkId=cf2c8abd-2308-47e3-947b-b9f7e981c117	1	0.1%
(Missing)	188	26.6%

Value	Count	Frequency (%)
	520	73.4%
(Missing)	188	26.6%

dvd_country
Unsupported

Missing Rejected Unsupported

Missing	705
Missing (%)	99.6%
Memory size	22.9 KiB

externals_tvrage
Real number (ℝ)

High correlation Missing

Distinct	23
Distinct (%)	100.0%
Missing	685
Missing (%)	96.8%
Infinite	0
Infinite (%)	0.0%
Mean	17498.696

Minimum	712
Maximum	47170
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	712
5-th percentile	1999.7
Q1	5036
median	15090
Q3	31222
95-th percentile	35682.6
Maximum	47170
Range	46458
Interquartile range (IQR)	26186

Descriptive statistics

Standard deviation	14066.247
Coefficient of variation (CV)	0.80384543
Kurtosis	-1.1312229
Mean	17498.696
Median Absolute Deviation (MAD)	11672
Skewness	0.45531338
Sum	402470
Variance	1.9785929 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
3418	1	0.1%
15090	1	0.1%
32413	1	0.1%
10092	1	0.1%
35853	1	0.1%
5199	1	0.1%
3005	1	0.1%
4920	1	0.1%
47170	1	0.1%
31493	1	0.1%
Other values (13)	13	1.8%
(Missing)	685	96.8%

Value	Count	Frequency (%)
712	1	0.1%
1888	1	0.1%
3005	1	0.1%
3256	1	0.1%
3418	1	0.1%
4920	1	0.1%
5152	1	0.1%
5199	1	0.1%
6659	1	0.1%
8531	1	0.1%

Value	Count	Frequency (%)
47170	1	0.1%
35853	1	0.1%
34149	1	0.1%
33858	1	0.1%
32413	1	0.1%
31493	1	0.1%
30951	1	0.1%
26056	1	0.1%
25100	1	0.1%
19056	1	0.1%

externals_thetvdb
Real number (ℝ)

High correlation Missing

Distinct	510
Distinct (%)	100.0%
Missing	198
Missing (%)	28.0%
Infinite	0
Infinite (%)	0.0%
Mean	390421.6

Minimum	70366
Maximum	457021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	70366
5-th percentile	242895.5
Q1	374678.5
median	423039.5
Q3	442143.5
95-th percentile	445129.7
Maximum	457021
Range	386655
Interquartile range (IQR)	67465

Descriptive statistics

Standard deviation	81308.181
Coefficient of variation (CV)	0.20825739
Kurtosis	5.5107192
Mean	390421.6
Median Absolute Deviation (MAD)	20814.5
Skewness	-2.3385838
Sum	1.9911502 × 10⁸
Variance	6.6110203 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
389662	1	0.1%
362235	1	0.1%
145431	1	0.1%
444655	1	0.1%
428163	1	0.1%
135211	1	0.1%
395604	1	0.1%
410849	1	0.1%
449126	1	0.1%
441368	1	0.1%
Other values (500)	500	70.6%
(Missing)	198	28.0%

Value	Count	Frequency (%)
70366	1	0.1%
71178	1	0.1%
71753	1	0.1%
71756	1	0.1%
72716	1	0.1%
76355	1	0.1%
76719	1	0.1%
76779	1	0.1%
78006	1	0.1%
78419	1	0.1%

Value	Count	Frequency (%)
457021	1	0.1%
454395	1	0.1%
451493	1	0.1%
449126	1	0.1%
448382	1	0.1%
447745	1	0.1%
447439	1	0.1%
447332	1	0.1%
447062	1	0.1%
446981	1	0.1%

externals_imdb
Text

Missing

Distinct	364
Distinct (%)	100.0%
Missing	344
Missing (%)	48.6%
Memory size	34.6 KiB

Length

Max length	10
Median length	10
Mean length	9.75
Min length	9

Characters and Unicode

Total characters	3549
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	364 ?
Unique (%)	100.0%

Sample

1st row	tt20603062
2nd row	tt15816496
3rd row	tt19756810
4th row	tt27432264
5th row	tt27801903

Value	Count	Frequency (%)
tt30249032	1	0.3%
tt0058796	1	0.3%
tt15816496	1	0.3%
tt19756810	1	0.3%
tt27432264	1	0.3%
tt27801903	1	0.3%
tt0088512	1	0.3%
tt0338653	1	0.3%
tt11847842	1	0.3%
tt7057262	1	0.3%
Other values (354)	354	97.3%

Most occurring characters

Value	Count	Frequency (%)
t	728	20.5%
2	406	11.4%
1	323	9.1%
0	320	9.0%
4	284	8.0%
8	280	7.9%
6	275	7.7%
3	270	7.6%
5	228	6.4%
9	222	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3549	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	728	20.5%
2	406	11.4%
1	323	9.1%
0	320	9.0%
4	284	8.0%
8	280	7.9%
6	275	7.7%
3	270	7.6%
5	228	6.4%
9	222	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3549	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	728	20.5%
2	406	11.4%
1	323	9.1%
0	320	9.0%
4	284	8.0%
8	280	7.9%
6	275	7.7%
3	270	7.6%
5	228	6.4%
9	222	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3549	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	728	20.5%
2	406	11.4%
1	323	9.1%
0	320	9.0%
4	284	8.0%
8	280	7.9%
6	275	7.7%
3	270	7.6%
5	228	6.4%
9	222	6.3%

updated
Real number (ℝ)

Unique

Distinct	708
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7230735 × 10⁹

Minimum	1.6991738 × 10⁹
Maximum	1.7390499 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1.6991738 × 10⁹
5-th percentile	1.7049509 × 10⁹
Q1	1.7089776 × 10⁹
median	1.7248104 × 10⁹
Q3	1.7366427 × 10⁹
95-th percentile	1.7389195 × 10⁹
Maximum	1.7390499 × 10⁹
Range	39876172
Interquartile range (IQR)	27665127

Descriptive statistics

Standard deviation	13227526
Coefficient of variation (CV)	0.0076767043
Kurtosis	-1.6384882
Mean	1.7230735 × 10⁹
Median Absolute Deviation (MAD)	12908616
Skewness	-0.13977696
Sum	1.219936 × 10¹²
Variance	1.7496743 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1704215354	1	0.1%
1716477793	1	0.1%
1705082793	1	0.1%
1739049934	1	0.1%
1720023117	1	0.1%
1738933330	1	0.1%
1706695649	1	0.1%
1738908292	1	0.1%
1707291460	1	0.1%
1737984176	1	0.1%
Other values (698)	698	98.6%

Value	Count	Frequency (%)
1699173762	1	0.1%
1699196321	1	0.1%
1700067953	1	0.1%
1701776723	1	0.1%
1703096478	1	0.1%
1703404987	1	0.1%
1703852377	1	0.1%
1703934794	1	0.1%
1704019326	1	0.1%
1704104449	1	0.1%

Value	Count	Frequency (%)
1739049934	1	0.1%
1739049891	1	0.1%
1739049038	1	0.1%
1739043766	1	0.1%
1739042508	1	0.1%
1739040763	1	0.1%
1739039426	1	0.1%
1739039394	1	0.1%
1739036311	1	0.1%
1739033647	1	0.1%

Interactions

Correlations

	averageRuntime	externals_thetvdb	externals_tvrage	id	language	rating	runtime	schedule_time	status	type	updated	weight
averageRuntime	1.000	-0.098	0.069	-0.062	0.000	0.023	0.993	0.346	0.098	0.291	0.037	0.102
externals_thetvdb	-0.098	1.000	0.936	0.832	0.215	-0.248	-0.175	0.408	0.218	0.195	-0.403	-0.428
externals_tvrage	0.069	0.936	1.000	0.214	0.493	-0.179	0.205	0.000	0.000	0.316	0.049	-0.297
id	-0.062	0.832	0.214	1.000	0.085	-0.236	-0.003	0.227	0.188	0.154	-0.288	-0.592
language	0.000	0.215	0.493	0.085	1.000	0.000	0.162	0.179	0.357	0.206	0.169	0.085
rating	0.023	-0.248	-0.179	-0.236	0.000	1.000	0.088	0.000	0.168	0.105	0.262	0.249
runtime	0.993	-0.175	0.205	-0.003	0.162	0.088	1.000	0.391	0.000	0.305	0.041	-0.005
schedule_time	0.346	0.408	0.000	0.227	0.179	0.000	0.391	1.000	0.182	0.218	0.000	0.125
status	0.098	0.218	0.000	0.188	0.357	0.168	0.000	0.182	1.000	0.379	0.314	0.182
type	0.291	0.195	0.316	0.154	0.206	0.105	0.305	0.218	0.379	1.000	0.130	0.097
updated	0.037	-0.403	0.049	-0.288	0.169	0.262	0.041	0.000	0.314	0.130	1.000	0.368
weight	0.102	-0.428	-0.297	-0.592	0.085	0.249	-0.005	0.125	0.182	0.097	0.368	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	id	url	name	type	language	genres	status	runtime	averageRuntime	premiered	ended	officialSite	schedule_time	schedule_days	rating	weight	summary	webChannel_name	webChannel_site	dvd_country	externals_tvrage	externals_thetvdb	externals_imdb	updated
0	51908	https://www.tvmaze.com/shows/51908/neznost	Нежность	Scripted	Russian	[Drama, Comedy, Romance]	Ended	NaN	19.0	2020-11-12	2024-01-01	https://www.ivi.ru/watch/nezhnost		<NA>	NaN	11	None	Иви	https://www.ivi.ru/	None	NaN	NaN	None	1704215354
1	59205	https://www.tvmaze.com/shows/59205/predposlednaa-instancia	Предпоследняя инстанция	Scripted	Russian	[Drama, Comedy, Supernatural]	Ended	NaN	26.0	2022-01-01	2024-01-08	https://okko.tv/serial/predposlednjaja-instancija		[Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday]	NaN	29	None	Okko	None	None	NaN	NaN	None	1704783571
2	59484	https://www.tvmaze.com/shows/59484/manuna	Манюня	Scripted	Russian	[Comedy, Adventure, Children]	Running	NaN	20.0	2021-12-15	None	https://okko.tv/serial/manjunja		[Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday]	6.3	31	None	Okko	None	None	NaN	413379.0	None	1703404987
3	72871	https://www.tvmaze.com/shows/72871/nedetskoe-kino	Недетское кино	Scripted	None	[Comedy, Fantasy]	Running	NaN	NaN	2024-01-01	None	https://wink.ru/series/ne-detskoe-kino-year-2023?ysclid=lpbaiai0cw654763598		<NA>	NaN	3	None	Wink	None	None	NaN	NaN	None	1704019326
4	73221	https://www.tvmaze.com/shows/73221/uspesnyj	Успешный	Scripted	Russian	[Comedy]	Running	NaN	NaN	2024-01-01	None	https://kion.ru/video/serial/822094895/season/822095042/episode/822094715		<NA>	NaN	6	<p>30-year-old Sasha is a serial loser trying with all his might to become a successful business coach. Fate leads him to billionaire Oleg Kalugin, who decides to hire the resilient dreamer as a coach. However, Kalugin does not need advice on business, which the guy knows nothing about, but the secret of his ability to sincerely enjoy life despite poverty and other problems. From this moment, drastic changes begin in Sasha's life, which show the real price of success. Step by step, he moves further and further away from happiness, plunging into the world of deception, betrayal, hatred and really big, but dirty money.</p>	KION	https://kion.ru/	None	NaN	NaN	None	1735808422
5	73590	https://www.tvmaze.com/shows/73590/kak-druza-zahara-zenili	Как друзья Захара женили	Scripted	None	[Comedy]	Ended	NaN	26.0	2024-01-01	2024-02-06	None		<NA>	NaN	16	None	Okko	None	None	NaN	NaN	None	1707351592
6	73893	https://www.tvmaze.com/shows/73893/imperatricy	Императрицы	Documentary	None	[Drama, History]	Ended	NaN	39.0	2024-01-01	2024-01-01	https://premier.one/show/imperatritsy-mini-serial		<NA>	NaN	3	None	Premier	https://premier.one/	None	NaN	NaN	None	1705416247
7	73780	https://www.tvmaze.com/shows/73780/planet-lulin	Planet Lulin	Scripted	English	[Children, Fantasy, Science-Fiction]	To Be Determined	NaN	22.0	2024-01-01	None	https://iview.abc.net.au/show/planet-lulin		<NA>	NaN	27	<p>Lulin wasn't expecting to develop alien powers, or intergalactic invaders to crash her school science comp, but hey, Year 6 is full of surprises!</p>	ABC iview	https://iview.abc.net.au/	None	NaN	444536.0	None	1705107854
8	55019	https://www.tvmaze.com/shows/55019/supreme-god-emperor	Supreme God Emperor	Animation	Chinese	[Adventure, Anime, Fantasy]	Running	10.0	10.0	2020-05-18	None	https://v.qq.com/x/search/?q=无上神帝&stag=&smartbox_ab=	10:00	[Monday, Friday]	NaN	49	<p>Ten thousand years ago, Muyun's fairy King was secretly accounted for by holding a Zhuxian figure, and after a long sleep, he awakened in the famous "Muyun waste" of the southern Yun Empire in the Land of Heaven. When Muyun first woke up, he was deliberately bothered by the student Miaoxianyu. Muyun easily completed the Miaoxianyu trap, and he gave more and more alchemy skills by analogy, so the Alchemy masters outside the door could not ask for appreciation. Endless back home, Mu Yun learns that he is about to marry Nona Qin Qin Mengyao. Qin Mengyao was cold and toxic, but could not live until he was 20 years old. The marriage was only for the sake of pastoralists and family of Qin. However, under Mu Linchen's enticement, Mu Yun approves the family's issue on the condition of alchemy.</p><p><br /> </p>	Tencent QQ	https://v.qq.com/	None	NaN	388383.0	tt20603062	1732535501
9	62143	https://www.tvmaze.com/shows/62143/against-the-sky-supreme	Against the Sky Supreme	Animation	Chinese	[Action, Adventure, Anime, Fantasy]	Running	NaN	7.0	2021-07-09	None	https://v.qq.com/x/cover/mzc00200azkttu2.html	10:00	[Monday, Friday]	7.8	82	<p>The former mighty Gods of the heavens, after ten thousand lifetimes of reincarnation tragically destroyed! The cruel curse, the hatred of ten thousand lives, Tan Yun determined, no longer sink! The most important thing is that you have to be able to get to the top of the world, step by step, stepping on the corpses of your enemies! To kill against the sky, across all the worlds, only I am the supreme!</p>	Tencent QQ	https://v.qq.com/	None	NaN	406729.0	tt15816496	1738619115

	id	url	name	type	language	genres	status	runtime	averageRuntime	premiered	ended	officialSite	schedule_days	rating	weight	summary	webChannel_name	webChannel_site	dvd_country	externals_tvrage	externals_thetvdb	externals_imdb	updated
698	34499	https://www.tvmaze.com/shows/34499/off-gun-fun-night	Off Gun Fun Night	Talk Show	Thai	[Drama, Comedy]	Ended	NaN	23.0	2017-11-12	2024-01-31	https://tv.line.me/offgunfunnight?lang=th_TH	<NA>	NaN	34	<p>A monthly talk show where Off and Gun host a special guest and a lot of fun and laughs ensue. Airs every 12th of the month.</p>	LINE TV	https://www.linetv.tw/	None	NaN	347036.0	None	1706727249
699	40868	https://www.tvmaze.com/shows/40868/gods-school-the-olympian-gods	Gods' School: The Olympian Gods	Animation	English	<NA>	Running	15.0	13.0	2019-01-31	None	https://www.youtube.com/channel/UC4E060sRvClagErOdYZZjVA	[Saturday]	NaN	21	<p>Mount Olympus is the divine sanctuary created by the Titans for the young gods and goddesses, Among the young immortals, one young goddess, Eris, is a black sheep. She has an horrible reputation, she doesn't fit the high standards of Mount Olympus and she is is being avoid like the plague. But her meeting with a mortal is going to change her divine destiny.</p>	YouTube	https://www.youtube.com	None	NaN	355452.0	tt8929826	1706859211
700	53613	https://www.tvmaze.com/shows/53613/marvel-studios-assembled	Marvel Studios: Assembled	Documentary	English	<NA>	Running	NaN	57.0	2021-03-12	None	https://disneyplus.com/series/marvel-studios-assembled/3RUQKboZV3FF	<NA>	7.9	95	<p><b>Marvel Studios: Assembled</b> is a comprehensive documentary series streaming on Disney+ that chronicles the creation of Marvel Studios' thrilling new shows and theatrical releases. Journey behind-the-scenes of productions such as <i>WandaVision</i>, <i>The Falcon and the Winter Soldier</i>, and <i>Loki</i> via exclusive on-set footage. <i>Assembled</i> is an immersive, and in-depth examination of the next phase of the Marvel Cinematic Universe.</p>	Disney+	https://www.disneyplus.com/	None	NaN	396948.0	tt14094206	1734639089
701	66629	https://www.tvmaze.com/shows/66629/love-never-lies-polska	Love Never Lies: Polska	Reality	Polish	[Romance]	To Be Determined	NaN	49.0	2023-01-25	None	https://www.netflix.com/title/81582706	<NA>	NaN	52	<p>Six couples test their trust with an eye-scanning lie detector in this reality series where deception costs money, and the truth comes with a prize.</p>	Netflix	https://www.netflix.com/	None	NaN	430211.0	tt25377596	1729271534
702	73378	https://www.tvmaze.com/shows/73378/choir	Choir	Documentary	English	[Family, Music]	Running	NaN	46.0	2024-01-31	None	https://www.disneyplus.com/series/choir/2ZObNbv5pKlj	<NA>	NaN	27	<p><b>Choir</b> follows the kids of the Detroit Youth Choir as they prepare for the performance of a lifetime. Through their eyes, we experience the highs and lows of life growing up in Detroit, navigating the challenges of balancing family, school, and athletics, all while pursuing their dreams of taking their talents to the next level and performing on one of the world's biggest stages. Following their 2019 appearance on America's Got Talent, it's a pivotal time for the choir and its director, Anthony White, as he's faced with the combined challenges of replacing several key members, keeping the choir relevant in Detroit, and finding the next big opportunity that will put them back in the national spotlight.</p>	Disney+	https://www.disneyplus.com/	None	NaN	443679.0	tt28080721	1706780799
703	73413	https://www.tvmaze.com/shows/73413/baby-bandito	Baby Bandito	Scripted	Spanish	[Drama, Crime, Thriller]	Ended	NaN	38.0	2024-01-31	2024-01-31	https://www.netflix.com/title/81619198	<NA>	5.3	42	<p>After skater Kevin and his crew pull off Chile's biggest heist, reckless love –and social media– threatens everyone's fortunes. Inspired by true events.</p>	Netflix	https://www.netflix.com/	None	NaN	444012.0	tt27997713	1706822844
704	73714	https://www.tvmaze.com/shows/73714/alexander-the-making-of-a-god	Alexander: The Making of a God	Documentary	English	[History]	Ended	NaN	39.0	2024-01-31	2024-01-31	https://www.netflix.com/title/81325194	<NA>	6.1	86	<p>Combining expert interviews with gripping reenactments, this docudrama explores the life of Alexander the Great through his conquest of the Persian Empire.</p>	Netflix	https://www.netflix.com/	None	NaN	444188.0	tt27494999	1707151653
705	74390	https://www.tvmaze.com/shows/74390/fighting-for-love	Fighting for Love	Scripted	Chinese	[Action, Romance, War]	Ended	NaN	45.0	2024-01-31	2024-02-21	https://www.iqiyi.com/v_26mc92p2eag.html	[Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday]	NaN	13	<p>The story follows Amai, a female general of the founding era of the Southern Xia dynasty, who discards her feminine attire and dons battle armor, enduring hardships to become a legendary female warrior. Amai (Zhang Tianai), the daughter of the Duke of Jingguo in Southern Xia, witnesses her entire family being killed by her childhood friend Chen Qi. Years later, Amai, now a young girl, disguises herself as a man and roams the martial world, seeking revenge against Chen Qi. Through a series of coincidences, Amai saves Shang Yizhi (Zhang Haowei), the son of the Grand Princess, and subsequently helps him escape from dangerous situations multiple times, intertwining their destinies. As war breaks out, Amai sheds her feminine attire and joins the military, becoming an infantry soldier. With her exceptional military talents, she achieves remarkable feats and rises to the rank of General Mai. Alongside this, she assists Shang Yizhi, who is hunted and faces difficulties, in finding his true self and accomplishing great deeds. On the battlefield, Amai repeatedly clashes with General Chang Yuqing (Wang Ruichang) from the enemy forces. Despite their confrontations, they unintentionally go through life-and-death situations together, developing a mutual understanding and respect. However, faced with the brutality of war, Amai willingly sets aside personal attachments and uses her youth and fervor to defend her army. Eventually, after the war's victory, Amai leaves the military, returns to her female identity, retreats from the world, and ultimately finds her own happiness.</p>	iQIYI	https://www.iq.com/	None	NaN	439696.0	None	1708493403
706	78088	https://www.tvmaze.com/shows/78088/hot-ones-versus	Hot Ones Versus	Talk Show	English	[Food]	Running	NaN	15.0	2024-01-31	None	https://www.youtube.com/playlist?list=PLAzrgbu8gEMKThlhJv0ftFDvsumn0f-HN	<NA>	NaN	45	<p>"Hot Ones" spin-off series where guests have two choices: Tell the truth, or suffer the wrath of the Last Dab. Whoever eats the most wings, loses.</p>	YouTube	https://www.youtube.com	None	NaN	NaN	tt31323246	1738724974
707	75220	https://www.tvmaze.com/shows/75220/sues-places	Sue's Places	Talk Show	English	[Sports]	Running	NaN	NaN	2024-01-31	None	https://www.espn.com/watch/series/0b15b405-50b7-4e8b-a553-cfee4ef2a89d/sues-places	[Wednesday]	NaN	8	<p>UConn legend Sue Bird explores the rich history, traditions and seminal moments of men's and women's college basketball.</p>	ESPN+	None	None	NaN	NaN	None	1710010766

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block